<?
session_start();
include "connectdb.php" ;
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ยินดีต้อนรับเข้าสู่ ระบบบริการสื่อมัลติมีเดียด้านการเกษตร</title>
<link rel="stylesheet" href="standard.css" type="text/css" />
<script>  
	function txtreset()
		{
		document.frmSearch.txtkeyword.value="";
		}
</script>
<?php 
function remember(){

		for ($i=0;$i<count($_GET["cb_array"]);$i++) {
				$cb_array = $cb_array[$i];
			}
			
}
?>


<script type="text/javascript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<script type="text/javascript">    
function setPic(imgShow){   
    var showBig=document.getElementById('bigGallDiv');   
    showBig.style.display='block';   		
	showBig.style.visibility='hidden';   
    showBig.innerHTML="<img src='"+imgShow+"' title='คลิกที่รูปเืพื่อปิด' >";   
	setTimeout("showPic()",500);
} 
function  showPic(){
	var showBig=document.getElementById('bigGallDiv');   
    var LeftVal=0;   	
    if(showBig.innerHTML!=""){   
		LeftVal=showBig.offsetWidth;      					
		LeftVal=(gWH().width-LeftVal)/2;   	
    }   
	showBig.style.left=LeftVal+"px";   
	showBig.style.visibility='visible';   	
}
function gWH(){ // ฟังก์ชันหาความกว้างและความสูงของหน้าเพจ   
    var e = window, a = 'inner';   
    if ( !( 'innerWidth' in window ) ){   
        a = 'client';   
        e = document.documentElement || document.body;   
    }   
    return { width : e[ a+'Width' ] , height : e[ a+'Height' ] }   
}  
</script>
</head>

<body onLoad="MM_preloadImages('img/m_main2.jpg','img/m_register2.jpg','img/m_multimedia2.jpg','img/m_manual2.jpg','img/m_evaluate2.jpg','img/m_admin2.jpg','img/m_static2.jpg','img/m_topten2.jpg')">
<table width="1024" height="659" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#666600">
  <tr>
    <td height="215" align="center" valign="top" bgcolor="#CCCCCC"><table width="1024" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="170" background="img/headNew2.jpg" bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
    </table>
        <table width="824" border="0" cellpadding="0" cellspacing="0" bordercolor="#FF0000">
          <tr>
            <td width="103" height="45" align="center"><a href="index.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image12','','img/m_main2.jpg',1)"><img src="img/m_main.jpg" name="Image12" width="115" height="45" border="0" id="Image12" /></a></td>
            <td width="103" align="right"><a href="user_register.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image13','','img/m_register2.jpg',1)"><img src="img/m_register.jpg" name="Image13" width="115" height="45" border="0" id="Image13" /></a></td>
            <td width="103" align="right"><a href="vdo_list.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image14','','img/m_multimedia2.jpg',1)"><img 
src="img/m_multimedia.jpg" name="Image14" width="117" height="45" border="0" id="Image14" /></a></td>
            <td width="103"><a href="vdo_top10.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image11','','img/m_topten2.jpg',1)"><img 
src="img/m_topten.jpg" name="Image11" width="115" height="45" border="0" id="Image11" /></a></td>
            <td width="103"><a href="admin_report_search.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image10','','img/m_static2.jpg',1)"><img 
src="img/m_static.jpg" name="Image10" width="215" height="45" border="0" id="Image10" /></a></td>
            <td width="103"><a href="manual.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image9','','img/m_manual2.jpg',1)"><img src="img/m_manual.jpg" name="Image9" width="117" height="45" border="0" id="Image9" /></a></td>
            <td width="103"><a href="evaluate_overview.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image8','','img/m_evaluate2.jpg',1)"><img src="img/m_evaluate.jpg" name="Image8" width="115" height="45" border="0" id="Image8" /></a></td>
            <td width="103"><a href="admin_login.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image15','','img/m_admin2.jpg',1)"><img src="img/m_admin.jpg" name="Image15" width="115" height="45" border="0" id="Image15" /></a></td>
          </tr>
        </table></td>
  </tr>
  <tr>
    <td width="1024" height="66" align="center" valign="top" bgcolor="#FFFFFF"><table width="1024" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="25" height="25" background="img/tb/tb_left_top.jpg">&nbsp;</td>
        <td height="25" background="img/tb/tb_top.jpg">&nbsp;</td>
        <td width="25" height="25" background="img/tb/tb_right_top.jpg">&nbsp;</td>
      </tr>
      <tr>
        <td width="25" align="left" background="img/tb/tb_left.jpg">&nbsp;</td>
        <td align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td height="30" align="left" bgcolor="#CCFF00" class="style7"><span class="scapmain style4 style12 style25 style9">&nbsp;<img src="img/img05.gif" align="absbottom" /></span> รายการสื่อมัลติมีเดีย</td>

<td align="right" bgcolor="#CCFF00" class="style7">
<? if(isset($_SESSION["sess_user_register"])){echo"<a href="."user_logout.php"."><img src="."pic/logout(red)_icon.jpeg"." width='30' alt='ออกจากระบบ' border='0'/></a>";} ?></td>
            <td align="right" bgcolor="#CCFF00" class="style7"><? if(isset($_SESSION["sess_Username"])){echo"<a href="."admin_logout.php"."><img src="."pic/logout(red)_icon.jpeg"." width='30' alt='ออกจากระบบ' border='0'/></a>";} ?></td>

          </tr>
          <tr>
            <td colspan="2" align="center" bgcolor="#FFFFFF"><table width="50%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td height="30">&nbsp;</td>
              </tr>
            </table>
              <table width="98%" height="247" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td align="center" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#999999">
                          <form action="<?=$_SERVER['SCRIPT_NAME'];?>" method="get" name="frmSearch" id="frmSearch" onsubmit="">
                              <tr>
                                <td width="74%" align="center" valign="middle" bgcolor="#CCFF00"><select name="txtfield" id="txtfield" >
                               	 	<option value="0" <? if($_GET["txtfield"] == '0') echo"selected" ?>>กรุณาเลือก</option>
                                    <option value="1" <? if($_GET["txtfield"] == '1') echo"selected" ?>>ค้นหาตามชื่อชุด</option>
                                    <option value="2" <? if($_GET["txtfield"] == '2') echo"selected" ?>>ค้นหาตามชื่อเรื่อง</option>
                                    <option value="3" <? if($_GET["txtfield"] == '3') echo"selected" ?>>ค้นหาตามคำสำคัญ</option>
                                    <option value="4" <? if($_GET["txtfield"] == '4') echo"selected" ?>>ค้นหาตามหน่วยงาน/ชื่อผู้แต่ง</option>
                                    <option value="5" <? if($_GET["txtfield"] == '5') echo"selected" ?>>ค้นหาตามปีที่จัดทำ</option>
                                    
                                  </select>
                                  &nbsp;:&nbsp;
                                  <input name="txtkeyword" type="text" id="txtkeyword" size="50" value="<?=$_GET["txtkeyword"];?>" />
                                  <input type="button" name="button2" id="button2" value="ล้าง"  onclick="txtreset()"/></td>
                                <td width="14%" align="left" valign="middle" nowrap="nowrap" bgcolor="#CCFF00" class="style20">
<input name="cb_array[0]" type="checkbox" value="วีดีโอ" <? 
if($_GET["cb_array"][0] != "วีดีโอ" and $_GET["cb_array"][1] != "เสียง"){echo"checked";}
elseif($_GET["cb_array"][0] == "วีดีโอ"){echo"checked";} ?> />

                                  &nbsp;<span class="style20">วีดีโอ</span><br />
<input name="cb_array[1]" type="checkbox" value="เสียง" <? 
if($_GET["cb_array"][0] != "วีดีโอ" and $_GET["cb_array"][1] != "เสียง"){echo"checked";}
elseif($_GET["cb_array"][1] == "เสียง"){echo"checked";} ?> />

                                &nbsp;<span class="style20">เสียง</span> </td>
                                <td width="12%" align="center" valign="middle" bgcolor="#CCFF00"><input type="submit" name="button" id="button" value="ค้นหา" /></td>
                            </tr>
                              <tr>
                                <td align="center" valign="middle" bgcolor="#CCCC00">
                                <span class="style24">หมวดหมู่</span> : 
<?php 
        $SQL_SELECT_VDOTYPE = "SELECT * FROM ag_vdotype ORDER BY vdo_typeid desc";
        $result = mysql_query($SQL_SELECT_VDOTYPE);
		$k = 0;
		$i = 0;
        while ( $rs = mysql_fetch_array( $result ) ) //นำค่าี่ที่ผ่านการคิวรี่จากตัวแปร $result มาทำการวนลูปเพื่อเอาค่าในแต่ละฟิลด์ออกมาโชว์แสดงผล
			{ 
			$vdo_typeid = $rs[vdo_typeid];									
			$vdo_type = $rs[vdo_type];													
			
			$bgcolorj = ($j++%2)?'#f7fdea':'#ffffff';
			
			?>
				<input type='checkbox' name='vdotype_array[<?=$i?>]' value=<?=$vdo_typeid?> <? if($_GET["vdotype_array"][$i] == $vdo_typeid) echo"checked"; ?>>
					   &nbsp;<font color='#372412' size='2'><?=$vdo_type?></font>&nbsp;&nbsp;
					 
             <?
			 $i++;
			}
			$k = $i;
					for ($i=0;$i<$k;$i++) 
					{
					$vdotypeid = $vdotype_array[$i];
					//echo"<br>"."vdotype_array[$i] = ".$vdotype_array[$i];
					
					//echo $vdotype_a;
					//echo" "."vdotypeid = ".$vdotypeid;
					//echo"vdoid = ".$id."<br>";
					if($vdotypeid == ""){
					$vdotypeid = 0;
					
					}else{
					$vdotypeid2 .= $vdotypeid.",";
					$vdotype_[$i] = "&vdotype_array[$i]=".$vdotype_array[$i];
					}
//						if($vdotypeid != "" and $i != count($vdotype_array)){
//						$vdotypeid2 .= $vdotypeid.",";
//						}else if($i<=count($vdotype_array) and $vdotypeid != ""){
//						$vdotypeid2 .= $vdotypeid;
//						}
//					$SQL_INSERT_TYPEDETAIL = "INSERT INTO ag_vdotypedetail VALUES('$id','$vdotypeid') ;";
//					$result_vdotypedetail = mysql_db_query($dbname,$SQL_INSERT_TYPEDETAIL) or die ("ไม่สามารถ insert vdotypedetail ได้");

					}		 
					$vdotypeid2 = substr($vdotypeid2,0,(strlen($vdotypeid2)-1));
	$condition_vdotype_where = "where ag_vdodetail.vdo_id IN (SELECT vdo_id from ag_vdotypedetail where vdo_typeid IN (".$vdotypeid2.") group by vdo_id )";
	$condition_vdotype_and = "and ag_vdodetail.vdo_id IN (SELECT vdo_id from ag_vdotypedetail where vdo_typeid IN (".$vdotypeid2.") group by vdo_id )";
					if(count($vdotype_array) == 0){
					$condition_vdotype_where = "";
					$condition_vdotype_and = "";
					}
					 //echo "<br>".$vdotypeid2;
      
 ?>                      			</td>
                                <td colspan="2" align="left" valign="middle" nowrap="nowrap" bgcolor="#CCCC00" class="style20">เรียงตาม 
                                  
                                  <select name="txtsort" id="txtsort" >
                               	 	<option value="0" <? if($_GET["txtsort"] == '0') echo"selected" ?>>กรุณาเลือก</option>
                                    <option value="1" <? if($_GET["txtsort"] == '1') echo"selected" ?>>ชื่อชุด</option>
                                    <option value="2" <? if($_GET["txtsort"] == '2') echo"selected" ?>>ชื่อเรื่อง</option>
                                    <option value="3" <? if($_GET["txtsort"] == '3') echo"selected" ?>>หน่วยงาน/ชื่อผู้แต่ง</option>
                                    <option value="4" <? if($_GET["txtsort"] == '4') echo"selected" ?>>ปีที่จัดทำ</option>
                                    <option value="5" <? if($_GET["txtsort"] == '5') echo"selected" ?>>การใช้บริการล่าสุด</option>
                                    <option value="6" <? if($_GET["txtsort"] == '6') echo"selected" ?>>จำนวนผู้ใช้บริการสูงสุด</option>
                                    <option value="7" <? if($_GET["txtsort"] == '7') echo"selected" ?>>ระดับความสนใจ</option>
                                    <option value="8" <? if($_GET["txtsort"] == '8') echo"selected" ?>>สื่อที่เพิ่มเข้ามาใหม่</option>
                                    <option value="9" <? if($_GET["txtsort"] == '9') echo"selected" ?>>สื่อที่มีการแนะนำ</option>
                                  </select>
                                 
                                </td>
                              </tr>
                            </form>
                        </table>
                          <p>
                            <? 
include "connectdb.php" ;
$tb="ag_vdodetail"; 
$count_cbarray = count($_GET["cb_array"]);

////ถ้าไม่เป็นค่าว่าง////
if($_GET["txtkeyword"] != "") 
{
		/////////////////////////////////////// เก็บสถิติคำค้น (word) //////////////////////////////////////////
			$txtkeyword = $_GET["txtkeyword"];
			$txtkeyword_array = array();
			$txtkeyword_array = explode(" ",$txtkeyword); //แยกคีย์เวิดตามช่องว่าง
			
		if(isset($_SESSION["sess_userid"]) and !isset($_SESSION["sess_Username"])){
			$user_id = $_SESSION["sess_userid"];

			//$count_txtkeyword_array = count($txtkeyword_array);

			for($i=0;$i<count($txtkeyword_array);$i++){
				$Fchar =  substr($txtkeyword_array[$i],0,1);
				if($Fchar == "-"){continue;} //คำไหนที่ใส่ not จะไม่เก็บลงฐานข้อมูล
				
				$SQL_SELECT_WORD="SELECT * FROM ag_word WHERE word='$txtkeyword_array[$i]' ;";
				$db_query=mysql_db_query($dbname,$SQL_SELECT_WORD);
				$num_rows=mysql_num_rows($db_query);
				
				$word_id = $db_query[word_id];
				
				if($num_rows == 0){ //ถ้าไม่ซ้ำก็ insert
					$one = 1;
					$SQL_SELECT_MAXWORD = "SELECT MAX(word_id) FROM ag_word ;";
					$resultmax = mysql_query($SQL_SELECT_MAXWORD);
					$resultmax2 = mysql_result($resultmax,0);
					$resultmax3 = $resultmax2+1;
		
					//echo"$resultmax2<br>";
					//echo"$resultmax3<br>";
		
					$SQL_INSERT_WORD = "INSERT INTO ag_word VALUES('$resultmax3','$txtkeyword_array[$i]','1') ;";
					$result = mysql_db_query($dbname,$SQL_INSERT_WORD)or die("ไม่สามารถเพิ่มคำค้นได้ (word)");
					
					$SQL_INSERT_SEARCH = "INSERT INTO ag_search VALUES('$user_id','$resultmax3') ;";
					$result = mysql_db_query($dbname,$SQL_INSERT_SEARCH)or die("ไม่สามารถเพิ่มสถิติการค้นได้ได้ (search)");			
					
				}else if($num_rows == 1){ //ถ้ามีคำซ้ำก็ update
					
					$SQL_UPDATE_WORD = "UPDATE ag_word SET word_count=word_count+1 WHERE word='$txtkeyword_array[$i]' ;";
					$result = mysql_db_query($dbname,$SQL_UPDATE_WORD)or die("ไม่สามารถ update คำค้นได้ (word)");
					
					$SQL_SELECT_WORDID = "SELECT word_id FROM ag_word WHERE word='$txtkeyword_array[$i]' ;";
					$db_query=mysql_query($SQL_SELECT_WORDID);
					$word_id = mysql_result($db_query,0);
					
					$SQL_INSERT_SEARCH = "INSERT INTO ag_search VALUES('$user_id','$word_id') ;";
					$result = mysql_db_query($dbname,$SQL_INSERT_SEARCH)or die("ไม่สามารถเพิ่มสถิติการค้นได้ได้ (search)");	
				}// จบ if else ใน
			}// จบ for loop
		}// จบ if else นอก
		////////////////////////////////////////////////////////////////////////////////////////////////
		if($_GET["txtfield"]=="1"){
		//$condition = " WHERE (vdo_series_name LIKE '%".$_GET["txtkeyword"]."%') ";  //อันเก่าก่อนที่จะค้นหาหลายคำ
		
			//////////// ฟังก์ชั่นแปลงข้อความค้นหาหลายคำ //////////////////
			for ($i=0;$i<count($txtkeyword_array);$i++){
				$Fchar =  substr($txtkeyword_array[$i],0,1);
				if($Fchar == "-"){
					$n = strlen($txtkeyword_array[$i]);
					$txtkeyword_array[$i] = substr($txtkeyword_array[$i],1,$n);
					
					echo "<br>n = ".$n;
					echo "<br>txtkeyword_array = ".$txtkeyword_array[$i]."<br>";
					if($i==0){
					$txtkeyword = "vdo_series_name not like '%".$txtkeyword_array[$i]."%' ";
					}else{
					$txtkeyword .= "and vdo_series_name not like '%".$txtkeyword_array[$i]."%' ";
					}
				}else{
					if($i==0){
					$txtkeyword = "vdo_series_name like '%".$txtkeyword_array[$i]."%' ";
					}else{
					$txtkeyword .= "or vdo_series_name like '%".$txtkeyword_array[$i]."%' ";
					}
				
				}
			}
			//////////// จบฟังก์ชั่นแปลงข้อความค้นหาหลายคำ //////////////////
			
		$condition = "WHERE ($txtkeyword) ";
		$condition .= "and vdo_series_name != '' ";		
				if($count_cbarray=='2'){
					$condition = $condition.$condition_vdotype_and;
					}
				else if($count_cbarray=='1'){
					
						for ($i=0;$i<$count_cbarray;$i++) {
						$cb_array = $cb_array[$i];
					}
						
							if($_GET["cb_array"][0]=="วีดีโอ"){
							$condition = $condition." AND media_typeid = '1' ".$condition_vdotype_and;
							}else if($_GET["cb_array"][1]=="เสียง"){
							$condition = $condition." AND media_typeid = '2' ".$condition_vdotype_and;
							}
						
					}else if($count_cbarray=='0'){
					$condition = $condition.$condition_vdotype_and;
					}
		
		}
		else if($_GET["txtfield"]=="2"){
		//$condition = " WHERE (vdo_name LIKE '%".$_GET["txtkeyword"]."%' OR vdo_desc LIKE '%".$_GET["txtkeyword"]."%') "; //อันเก่าก่อนที่จะค้นหาหลายคำ

			//////////// ฟังก์ชั่นแปลงข้อความค้นหาหลายคำ //////////////////
			for ($i=0;$i<count($txtkeyword_array);$i++){
				$Fchar =  substr($txtkeyword_array[$i],0,1);
				if($Fchar == "-"){
					$n = strlen($txtkeyword_array[$i]);
					$txtkeyword_array[$i] = substr($txtkeyword_array[$i],1,$n);
					
					echo "<br>n = ".$n;
					echo "<br>txtkeyword_array = ".$txtkeyword_array[$i]."<br>";
					if($i==0){
					$txtkeyword = "vdo_name not like '%".$txtkeyword_array[$i]."%' ";
					}else{
					$txtkeyword .= "and vdo_name not like '%".$txtkeyword_array[$i]."%' ";
					}
				}else{
					if($i==0){
					$txtkeyword = "vdo_name like '%".$txtkeyword_array[$i]."%' ";
					}else{
					$txtkeyword .= "or vdo_name like '%".$txtkeyword_array[$i]."%' ";
					}
				
				}
			}
			//////////// จบฟังก์ชั่นแปลงข้อความค้นหาหลายคำ //////////////////
			
		$condition = "WHERE ($txtkeyword) ";
		$condition .= "and vdo_name != '' ";		
				if($count_cbarray=='2'){
					$condition = $condition.$condition_vdotype_and;
					}
				else if($count_cbarray=='1'){
					
						for ($i=0;$i<$count_cbarray;$i++) {
						$cb_array = $cb_array[$i];
					}
						
							if($_GET["cb_array"][0]=="วีดีโอ"){
							$condition = $condition." AND media_typeid = '1' ".$condition_vdotype_and;
							}else if($_GET["cb_array"][1]=="เสียง"){
							$condition = $condition." AND media_typeid = '2' ".$condition_vdotype_and;
							}
						
					}else if($count_cbarray=='0'){
					$condition = $condition.$condition_vdotype_and;
					}
		
		}
		else if($_GET["txtfield"]=="3"){
		//$condition = "WHERE (vdo_keyword LIKE '%".$_GET["txtkeyword"]."%') ";  //อันเก่าก่อนที่จะค้นหาหลายคำ
		
		//$condition = "WHERE (vdo_name LIKE '%".$_GET["txtkeyword"]."%' OR vdo_keyword LIKE '%".$_GET["txtkeyword"]."%') ";
		//$condition = " WHERE (vdo_name LIKE '%".$_POST["txtkeyword"]."%') ";

			//////////// ฟังก์ชั่นแปลงข้อความค้นหาหลายคำ //////////////////
			for ($i=0;$i<count($txtkeyword_array);$i++){
				$Fchar =  substr($txtkeyword_array[$i],0,1);
				if($Fchar == "-"){
					$n = strlen($txtkeyword_array[$i]);
					$txtkeyword_array[$i] = substr($txtkeyword_array[$i],1,$n);
					
					echo "<br>n = ".$n;
					echo "<br>txtkeyword_array = ".$txtkeyword_array[$i]."<br>";
					if($i==0){
					$txtkeyword = "vdo_keyword not like '%".$txtkeyword_array[$i]."%' ";
					}else{
					$txtkeyword .= "and vdo_keyword not like '%".$txtkeyword_array[$i]."%' ";
					}
				}else{
					if($i==0){
					$txtkeyword = "vdo_keyword like '%".$txtkeyword_array[$i]."%' ";
					}else{
					$txtkeyword .= "or vdo_keyword like '%".$txtkeyword_array[$i]."%' ";
					}
				
				}
			}
			//////////// จบฟังก์ชั่นแปลงข้อความค้นหาหลายคำ //////////////////
			
		$condition = "WHERE ($txtkeyword) ";		
		$condition .= "and vdo_keyword != '' ";
			if($count_cbarray=='2'){
			$condition = $condition.$condition_vdotype_and;
			}
			else if($count_cbarray=='1'){
			
				for ($i=0;$i<$count_cbarray;$i++) {
				$cb_array = $cb_array[$i];
				}
				
					if($_GET["cb_array"][0]=="วีดีโอ"){
					$condition = $condition." AND media_typeid = '1' ".$condition_vdotype_and;
					}else if($_GET["cb_array"][1]=="เสียง"){
					$condition = $condition." AND media_typeid = '2' ".$condition_vdotype_and;
					}
				
			}else if($count_cbarray=='0'){
					$condition = $condition.$condition_vdotype_and;
			}
		}		
		else if($_GET["txtfield"]=="4"){
//		$condition = "WHERE (vdo_author LIKE '%".$_GET["txtkeyword"]."%') ";  //อันเก่าก่อนที่จะค้นหาหลายคำ

			//////////// ฟังก์ชั่นแปลงข้อความค้นหาหลายคำ //////////////////
			for ($i=0;$i<count($txtkeyword_array);$i++){
				$Fchar =  substr($txtkeyword_array[$i],0,1);
				if($Fchar == "-"){
					$n = strlen($txtkeyword_array[$i]);
					$txtkeyword_array[$i] = substr($txtkeyword_array[$i],1,$n);
					
					echo "<br>n = ".$n;
					echo "<br>txtkeyword_array = ".$txtkeyword_array[$i]."<br>";
					if($i==0){
					$txtkeyword = "vdo_author not like '%".$txtkeyword_array[$i]."%' ";
					}else{
					$txtkeyword .= "and vdo_author not like '%".$txtkeyword_array[$i]."%' ";
					}
				}else{
					if($i==0){
					$txtkeyword = "vdo_author like '%".$txtkeyword_array[$i]."%' ";
					}else{
					$txtkeyword .= "or vdo_author like '%".$txtkeyword_array[$i]."%' ";
					}
				
				}
			}
			
			//////////// จบฟังก์ชั่นแปลงข้อความค้นหาหลายคำ //////////////////
			
		$condition = "WHERE ($txtkeyword) ";		
		$condition .= "and vdo_author != '' ";
			if($count_cbarray=='2'){
			$condition = $condition.$condition_vdotype_and;
			}
			else if($count_cbarray=='1'){
			
				for ($i=0;$i<$count_cbarray;$i++) {
				$cb_array = $cb_array[$i];
				}
				
					if($_GET["cb_array"][0]=="วีดีโอ"){
					$condition = $condition." AND media_typeid = '1' ".$condition_vdotype_and;
					}else if($_GET["cb_array"][1]=="เสียง"){
					$condition = $condition." AND media_typeid = '2' ".$condition_vdotype_and;
					}
				
			}else if($count_cbarray=='0'){
					$condition = $condition.$condition_vdotype_and;
			}
		}
		else if($_GET["txtfield"]=="5"){
		//$condition = "WHERE (vdo_year LIKE '%".$_GET["txtkeyword"]."%') ";		
	
			//////////// ฟังก์ชั่นแปลงข้อความค้นหาหลายคำ //////////////////
			for ($i=0;$i<count($txtkeyword_array);$i++){
				$Fchar =  substr($txtkeyword_array[$i],0,1);
				if($Fchar == "-"){
					$n = strlen($txtkeyword_array[$i]);
					$txtkeyword_array[$i] = substr($txtkeyword_array[$i],1,$n);
					
					echo "<br>n = ".$n;
					echo "<br>txtkeyword_array = ".$txtkeyword_array[$i]."<br>";
					if($i==0){
					$txtkeyword = "vdo_year not like '%".$txtkeyword_array[$i]."%' ";
					}else{
					$txtkeyword .= "and vdo_year not like '%".$txtkeyword_array[$i]."%' ";
					}
				}else{
					if($i==0){
					$txtkeyword = "vdo_year like '%".$txtkeyword_array[$i]."%' ";
					}else{
					$txtkeyword .= "or vdo_year like '%".$txtkeyword_array[$i]."%' ";
					}
				
				}
			}
			//////////// จบฟังก์ชั่นแปลงข้อความค้นหาหลายคำ //////////////////
			
		$condition = "WHERE ($txtkeyword) ";
		$condition .= "and vdo_year != '' ";
			if($count_cbarray=='2'){
			$condition = $condition.$condition_vdotype_and;
			}
			else if($count_cbarray=='1'){
			
				for ($i=0;$i<$count_cbarray;$i++) {
				$cb_array = $cb_array[$i];
				}
				
					if($_GET["cb_array"][0]=="วีดีโอ"){
					$condition = $condition." AND media_typeid = '1' ".$condition_vdotype_and;
					}else if($_GET["cb_array"][1]=="เสียง"){
					$condition = $condition." AND media_typeid = '2' ".$condition_vdotype_and;
					}
				
			}else if($count_cbarray=='0'){
					$condition = $condition.$condition_vdotype_and;
			}
		}
}
	////ถ้าเป็นค่าว่าง////
else if ($_GET["txtkeyword"] == "")
{
		if($count_cbarray=='2'){
		$condition = "".$condition_vdotype_where;
		}else if($count_cbarray=='1'){
		
			for ($i=0;$i<$count_cbarray;$i++) {
			$cb_array = $cb_array[$i];
			}
			
				if($_GET["cb_array"][0]=="วีดีโอ"){
				$condition = "WHERE media_typeid = '1' ".$condition_vdotype_and;
				}else if($_GET["cb_array"][1]=="เสียง"){
				$condition = "WHERE media_typeid = '2' ".$condition_vdotype_and;
				}
			
		}else if($count_cbarray=='0'){
					$condition = $condition.$condition_vdotype_where;
		}
	
}
//////////////////// ตรวจสอบการ sort /////////////////////

	$txtorderby = "vdo_viewrecent desc , vdo_dateadd desc , vdo_id desc";
	 
if($_GET["txtsort"] == "1"){
	$txtorderby = "vdo_series_name asc";
}elseif($_GET["txtsort"] == "2"){
	$txtorderby = "vdo_name asc";
}elseif($_GET["txtsort"] == "3"){
	$txtorderby = "vdo_author asc";
}elseif($_GET["txtsort"] == "4"){
	$txtorderby = "vdo_year desc";
}elseif($_GET["txtsort"] == "5"){
	$txtorderby = "vdo_viewrecent desc";
}elseif($_GET["txtsort"] == "6"){
	$txtorderby = "vdo_view desc";
}elseif($_GET["txtsort"] == "7"){
	$txtorderby = "(vdo_votesum/vdo_votecount) desc , vdo_votecount desc";
}elseif($_GET["txtsort"] == "8"){
	$txtorderby = "vdo_dateadd desc , vdo_id desc";
}elseif($_GET["txtsort"] == "9"){
	$txtorderby = "vdo_recommend desc , vdo_viewrecent desc";
}

//////////////////// จบการตรวจสอบการ sort /////////////////////

mysql_select_db($dbname) or die("เลือกฐานข้อมูลไม่ได้"); /* ทําการเลือกฐานขอมูลกอน */ 
//$sql="SELECT * FROM $tb $condition ORDER BY vdo_viewrecent desc , vdo_dateadd desc ";  //เรียงตามวันที่ดูล่าสุด ดูล่าสุดอยู่บน
$sql="SELECT * FROM $tb $condition ORDER BY $txtorderby "; 
$db_query=mysql_db_query($dbname,$sql); 
$num_rows=mysql_num_rows($db_query); /* นับ Reccord ทีพบ */
//echo $sql;
$Per_Page = 10;   // จำนวนรายการสื่อมัลติมีเดียต่อ 1 หน้า
 
    $Page = $_GET["Page"];
    if(!$_GET["Page"])
    {
        $Page=1;
    }
 
    $Prev_Page = $Page-1;
    $Next_Page = $Page+1;
 
    $Page_Start = (($Per_Page*$Page)-$Per_Page);
    if($num_rows<=$Per_Page)
    {
        $Num_Pages =1;
    }
    else if(($num_rows % $Per_Page)==0)
    {
        $Num_Pages =($num_rows/$Per_Page) ;
    }
    else
    {
        $Num_Pages =($num_rows/$Per_Page)+1;
        $Num_Pages = (int)$Num_Pages;
    }
 
 
    $sql .="  LIMIT $Page_Start , $Per_Page";
	$db_query=mysql_db_query($dbname,$sql); 


if($num_rows == '0'){
echo"<left><br><div align='center' class='style8'>ไม่พบข้อมูลที่ต้องการ</div></left>"; 
}else{
echo"<left><br><div align='center' class='style8'>จํานวน $num_rows รายการ</div></left>"; 

echo"<hr>";
 }                         
?>
                            <?  ///////////////// วน loop แสดงข้อมูล //////////////////////

$a=0; 
$colorzero="#FFF2A4";
$colorone="#FEE86E";
$bgcolor="";
$vdo_icon = "wmv_icon.gif";
$sound_icon = "wma_icon.jpg";
$unknow_icon = "unknow_icon.jpg";
//while($a < $num_rows) 
$j = (($Page*$Per_Page)-$Per_Page)+1;		//คำนวนเลขหน้ารายการ
if($Page == 1){$j = 1;}
while($result = mysql_fetch_array($db_query)) 
{ 
//$result = mysql_fetch_array($db_query); 
$vdo_id=			$result[vdo_id];
$vdo_series_name=	$result[vdo_series_name];
$vdo_name=			$result[vdo_name];
$vdo_desc=			$result[vdo_desc];
$vdo_author=		$result[vdo_author];
$vdo_year=			$result[vdo_year];
$vdo_cover=			$result[vdo_cover];
$vdo_length=		$result[vdo_length];
$vdo_view=			$result[vdo_view];
$vdo_dateadd=		$result[vdo_dateadd];
$vdo_keyword=		$result[vdo_keyword];
$vdo_keyword_array = array();
$vdo_keyword_array=explode(",",$vdo_keyword);
$mediatype=$result[media_typeid];

if($vdo_cover==""){
$vdo_cover_word = "NO PICTURE";
}else $vdo_cover_word = "<img src='$vdo_cover' width='200' />";


if($mediatype==1){
	$vdo_pic=$vdo_icon;
} else if($mediatype==2){
	$vdo_pic=$sound_icon;
}else $vdo_pic=$unknow_icon;
//$vdo_view=$result[vdo_name]; 
$_SESSION["sess_Url"]=$result[vdo_url]; 

//$SQL_SELECT_RATING="SELECT * FROM ag_vdodetail where vdo_id = $vdo_id";
//$db_query_rating=mysql_db_query($dbname,$SQL_SELECT_RATING); 
//$result_rating = mysql_fetch_array($db_query_rating); 
$votesum=$result[vdo_votesum]; 
$votecount=$result[vdo_votecount]; 

if($votesum==0 and $votecount==0){
$rating=0;
$votecount=0;
} else $rating = $votesum/$votecount;
////////// ปัดเศษทศนิยม ถ้าน้อยกว่า 0.5 ให้ปัดลง 0.5-0.75 ให้ปัดลงเศษ 0.5 ถ้า 0.75-1 ให้ปัดขึ้น //////////
		if(($rating-(int)$rating)>=0.5 and ($rating-(int)$rating)<0.75)
		{$rating++;
		$rating=(int)$rating-0.5;
		}
		else if(($rating-(int)$rating)>=0.75 and ($rating-(int)$rating)<1)
		{
		$rating++;
		$rating=(int)$rating;
		}
		else $rating=(int)$rating;
//////////////////////////////จบการปัดเศษ//////////////////////////////
if (($a % 2) == 0) {
$bgcolor=$colorzero;
}
else $bgcolor=$colorone;

//========== vdo ใหม่จะไม่เกิน 4 อาทิตย์ นับจากวันที่เพิ่มข้อมูลลงไป ===========//
//$today = Date("Y/m/d");
//$str = $vdo_dateadd;  
//list($year,$month,$day) = explode("/",$str);  
//$mydate = (int)($year.$month.$day);
////echo "$mydate";  
//
////echo'<br>';
//
//$str = $today;  
//list($year2,$month2,$day2) = explode("/",$str); 
//$today =  (int)($year2.$month2.$day2);
////echo "$today";  

$SQL_SELECT_DAY = "SELECT DATEDIFF(curdate(),vdo_dateadd) FROM ag_vdodetail where vdo_id = '$vdo_id' ";
$resultday = mysql_query($SQL_SELECT_DAY);
$resultday2 = mysql_result($resultday,0);
//================================================================//

////////////ตรวจสอบว่ามีการทำแบบประเมินหรือไม่//////////////////////
mysql_select_db($dbname) or die("เลือกฐานข้อมูลไม่ได้"); /* ทําการเลือกฐานขอมูลกอน */ 
$sql_eva="SELECT * FROM ag_evaluate_vdoans WHERE vdo_id = $vdo_id ;"; 
$db_query_eva=mysql_db_query($dbname,$sql_eva);  
$num_rows_eva=mysql_num_rows($db_query_eva); /* นับ Reccord ทีพบ */
	if (empty($num_rows_eva)){
	$evalink = "";
	}else $evalink = "<img src='pic/eva_result.gif' width='16' height='16' border='0' />";
////////////////////จบการตรวจสอบ/////////////////////////////

	
	  
	  if($vdo_cover == ""){$vdo_cover = "pic/no_image.gif";}
	


?>
                          </p>
                          <table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr>
                              <td align="center"><table width="99%" border="0" cellspacing="0" cellpadding="0">
                                  <tr>
                                    <td width="22%" rowspan="8" align="center">
                                    <div class="bigGallPic" id="bigGallDiv" onclick="this.style.display='none'"></div>
                  <a href="javascript:setPic('<?=$vdo_cover?>');"><img src="<?=$vdo_cover?>" border="0" width="150" height='150' hspace='5' vspace='5' /></a></td>
                                    <td height="20" align="left" class="style28"><span class="style8">หมายเลข :</span><span class="style24"> <? echo $vdo_id;?></span></td>
                                    <td width="35%" height="20" align="left" class="style28"><span class="style8">หมวดหมู่</span><span class="style8"> : </span>
                                        <?php 

        $SQL_SELECT_VDOTYPE = "SELECT * FROM ag_vdotype ORDER BY vdo_typeid desc";
        $result = mysql_query($SQL_SELECT_VDOTYPE);
        while ( $rs = mysql_fetch_array( $result ) ) //นำค่าี่ที่ผ่านการคิวรี่จากตัวแปร $result มาทำการวนลูปเพื่อเอาค่าในแต่ละฟิลด์ออกมาโชว์แสดงผล
	{ 
			$vdo_typeid = $rs[vdo_typeid];									
			$vdo_type = $rs[vdo_type];	
			
			$SQL_SELECT_VDOTYPEDETAIL = "SELECT * FROM ag_vdotypedetail WHERE vdo_id=$vdo_id and vdo_typeid=$vdo_typeid ";	
			$result_typedetail = mysql_query($SQL_SELECT_VDOTYPEDETAIL);											
			$num_rows_s=mysql_num_rows($result_typedetail);
			if($num_rows_s == 1) echo $vdo_type."&nbsp;&nbsp;";
	}
	?></td>
                                  </tr>
                                  <tr>
                                    <td height="20" align="left" class="style28"><span class="style8">ชื่อชุด :</span> <span class="style26"><?echo"$vdo_series_name";?></span></td>
                                    <td width="35%" height="20" align="left" class="style28"><span class="style8">จำนวนผู้ใช้บริการ  :</span> <span class="style24"><?echo"$vdo_view";?></span></td>
                                  </tr>
                                  <tr>
                                    <td height="20" align="left" class="style28"><span class="style8">ชื่อเรื่อง :</span> <a href="vdo_player.php?id=<?=$vdo_id?>" target="_self"><?echo"$vdo_name";?></a>
                                        <?php if($resultday2 <= 30) echo "<img src='pic/new.gif' />"; ?></td>
                                    <td width="35%" height="20" align="left" class="style28"><span class="style8">ระดับความสนใจ  :</span> <span class="style24"><img src="pic/star_<?=$rating?>.gif" width="50" /></span></td>
                                  </tr>
                                  <tr>
                                    <td height="20" align="left" class="style28"><span class="style26"><span class="style8">คำอธิบาย :</span> <? echo substr("$vdo_desc",0,200)."..."; ?></span></td>
                                    <td width="35%" height="20" align="left" class="style28"><span class="style8">จำนวนผู้โหวต :</span> <span class="style24"><?echo"$votecount";?></span></td>
                                  </tr>
                                  <tr>
                                    <td height="20" align="left" class="style28"><span class="style8">คำสำคัญ :</span> <span class="style24">
                                      <? 
	  if($vdo_keyword != ""){for ($i=0;$i<count($vdo_keyword_array);$i++)
	  {echo "<a href='$_SERVER[SCRIPT_NAME]?txtfield=3&txtkeyword=$vdo_keyword_array[$i]' target='_self'>$vdo_keyword_array[$i]</a>"." ";}  
	  }else echo "-"; 
	  ?>
                                      <?php //echo "$vdo_cover_word" 
	  
	  if($vdo_cover == ""){$vdo_cover = "pic/unknow_icon.jpg";}
	  ?>
                                    </span></td>
                                    <td width="35%" height="20" align="left" class="style28"><span class="style8">ผลการประเมิน</span><span class="style8"> :</span> <a href="vdo_evaluate_result.php?id=<?=$vdo_id?>&amp;vdo_name=<?=$vdo_name?>" target="_self"><? echo "$evalink"; ?></a></td>
                                  </tr>
                                  <tr>
                                    <td height="20" align="left" class="style28"><span class="style8">หน่วยงาน / ชื่อผู้แต่ง :</span> <span class="style26"><?echo"$vdo_author";?></span></td>
                                    <td width="35%" height="20" align="left" class="style28"><span class="style8">ประเภทไฟล์</span> :<span class="style26"> <img src='pic/<?=$vdo_pic?>' width='16'  border='0' align="middle" /></span></td>
                                  </tr>
                                  <tr>
                                    <td height="20" align="left" class="style28"><span class="style26"><span class="style8">ความยาว :</span> <?echo"$vdo_length";?></span></td>
                                    <td width="35%" height="20" align="left" class="style28">&nbsp;</td>
                                  </tr>
                                  <tr>
                                    <td align="left" class="style28"><span class="style8">ปีที่จัดทำ :</span> <span class="style26"><?echo"$vdo_year";?></span></td>
                                    <td width="35%" align="left" class="style28">&nbsp;</td>
                                  </tr>
                              </table></td>
                            </tr>
                          </table>
                          <hr />
                          <? 
$j++;
$a++; 
} 
echo"<br>";
//echo"<center><br>จํานวน Reccord = $num_rows</center>"; 
//mysql_close(); 
?>
                          <!--Total <?php /*?><?= $num_rows;?><?php */?> Record :-->
                          <?php /*?><?=$Num_Pages;?><?php */?>
                          <!--Page :-->
                          <?
 	$cbarray0 = '&cb_array[0]=';
 	if($_GET["cb_array"][0] == "วีดีโอ") {
	$cbarray0 = '&cb_array[0]='.$_GET["cb_array"][0];
	}else $cbarray0 = '';
	
	//หรืออันนี้ '&cb_array[0]=%E0%B8%A0%E0%B8%B2%E0%B8%9E%E0%B9%81%E0%B8%A5%E0%B8%B0%E0%B9%80%E0%B8%AA%E0%B8%B5%E0%B8%A2%E0%B8%87&'
	
	$cbarray1 = '&cb_array[1]=';
	if($_GET["cb_array"][1] == "เสียง"){
	$cbarray1 = '&cb_array[1]='.$_GET["cb_array"][1];
	}else $cbarray1 = '';
	
	for($i=0;$i<$k;$i++){
	$vdotype .= $vdotype_[$i];
	}			  
				  
				  
    if($Prev_Page)
    {
        echo " <b><a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page
		&txtfield=$_GET[txtfield]
		&txtsort=$_GET[txtsort]
		&txtkeyword=$_GET[txtkeyword]
		$cbarray1
		$cbarray0
		$vdotype
		' ><font color = #006600><< ก่อนหน้า</font></a></b> "; //&cb_array[]=ภาพและเสียง&cb_array[]=เสียง&button=Search
    }
 
    for($i=1; $i<=$Num_Pages; $i++){
        if($i != $Page)
        {
            echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$i
			&txtfield=$_GET[txtfield]
			&txtsort=$_GET[txtsort]
			&txtkeyword=$_GET[txtkeyword]
			$cbarray1
			$cbarray0
			$vdotype
			'><font color = #006600>$i</font></a> ";
        }
        else
        {
           if($num_rows != '0') echo "<b><font color = black>[ $i ]</font></b>";
        }
    }
    if($Page!=$Num_Pages)
    {
        echo " <b><a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page
		&txtfield=$_GET[txtfield]
		&txtsort=$_GET[txtsort]
		&txtkeyword=$_GET[txtkeyword]
		$cbarray1
		$cbarray0
		$vdotype	
		'><font color = #006600>ถัดไป >></font></a></b> ";
    }
     
    mysql_close();
 
     
    ?></td>
                      </tr>
                    </table>
                    <p>&nbsp;</p></td>
          </tr>
          <tr>
            <td height="25" colspan="2" bgcolor="#CCFF00">&nbsp;</td>
          </tr>
        </table></td>
        <td width="25" align="right" background="img/tb/tb_right.jpg">&nbsp;</td>
      </tr>
      <tr>
        <td width="25" height="25" background="img/tb/tb_left_foot.jpg">&nbsp;</td>
        <td height="25" background="img/tb/tb_foot.jpg">&nbsp;</td>
        <td width="25" height="25" background="img/tb/tb_right_foot.jpg">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td width="1024" align="center" valign="bottom"><table width="50%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="25">&nbsp;</td>
      </tr>
    </table>
        <table width="1024" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td height="50"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td width="25" height="25" background="img/tb/tb_left_top.jpg">&nbsp;</td>
                  <td background="img/tb/tb_top.jpg">&nbsp;</td>
                  <td width="25" height="25" background="img/tb/tb_right_top.jpg">&nbsp;</td>
                </tr>
                <tr>
                  <td width="25" align="left" background="img/tb/tb_left.jpg">&nbsp;</td>
                  <td height="25" align="center" valign="middle" bgcolor="#CCFF00"><table width="96%" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td height="25" align="center"><strong>ศูนย์ความรู้ด้านการเกษตร สำนักหอสมุด มหาวิทยาลัยเกษตรศาสตร์</strong></td>
                      </tr>
                  </table></td>
                  <td width="25" align="right" background="img/tb/tb_right.jpg">&nbsp;</td>
                </tr>
                <tr>
                  <td width="25" height="25" background="img/tb/tb_left_foot.jpg">&nbsp;</td>
                  <td background="img/tb/tb_foot.jpg">&nbsp;</td>
                  <td width="25" height="25" background="img/tb/tb_right_foot.jpg">&nbsp;</td>
                </tr>
            </table></td>
          </tr>
      </table></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>
